SherbyNet - /page/wikibook/entry.mu

Micron Document

`:top

`!Drizzle`! is a discontinued `F33f`_`[free software`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Free_software]`_`f/`F33f`_`[open-source`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Open-source_software]`_`f relational `F33f`_`[database management system`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_management_system]`_`f (DBMS) that was `F33f`_`[forked`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Fork_(software_development)]`_`f from the now-defunct 6.0 development branch of the `F33f`_`[MySQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=MySQL]`_`f DBMS.`:cite-ref-2[`F5bf`_`[2`#cite-note-2]`_`f]

Like MySQL, Drizzle had a `F33f`_`[client/server`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Client/server]`_`f architecture and uses `F33f`_`[SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f as its primary `F33f`_`[command language`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Command_language]`_`f. Old Drizzle files are distributed under version 2 and 3 of the `F33f`_`[GNU General Public License`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=GNU_General_Public_License]`_`f (GPL) with portions, including the protocol drivers and `F33f`_`[replication`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_replication]`_`f messaging under the `F33f`_`[BSD`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=BSD_licenses]`_`f license.

Early work on the fork was done mid-2008 by `F33f`_`[Brian Aker`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Brian_Aker]`_`f.`:cite-ref-3[`F5bf`_`[3`#cite-note-3]`_`f] Ongoing development was handled by a team of contributors that included staff members from `F33f`_`[Canonical Ltd.`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Canonical_Ltd.]`_`f, `F33f`_`[Google`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Google]`_`f, `F33f`_`[Six Apart`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Six_Apart]`_`f, `F33f`_`[Sun Microsystems`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Sun_Microsystems]`_`f, `F33f`_`[Rackspace`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Rackspace]`_`f, Data Differential, Blue Gecko, `F33f`_`[Intel`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Intel]`_`f, `F33f`_`[Percona`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Percona]`_`f, `F33f`_`[Hewlett-Packard`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Hewlett-Packard]`_`f, `F33f`_`[Red Hat`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Red_Hat]`_`f, and others.`:cite-ref-4[`F5bf`_`[4`#cite-note-4]`_`f] Drizzle source code, along with instructions on compiling it, are available via the project's `F33f`_`[Launchpad`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Launchpad_(website)]`_`f website.`:cite-ref-5[`F5bf`_`[5`#cite-note-5]`_`f]

In October 2010, Drizzle had 13,478 total contributions, 96 total contributors, and 37 active contributors.`:cite-ref-6[`F5bf`_`[6`#cite-note-6]`_`f] It was also announced that Drizzle had entered Beta.`:cite-ref-7[`F5bf`_`[7`#cite-note-7]`_`f] The first GA version was released in March 2011.`:cite-ref-8[`F5bf`_`[8`#cite-note-8]`_`f] Drizzle has actively participated in the `F33f`_`[Google Summer of Code Project`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Google_Summer_of_Code]`_`f since 2010.`:cite-ref-9[`F5bf`_`[9`#cite-note-9]`_`f]`:cite-ref-10[`F5bf`_`[10`#cite-note-10]`_`f]`:cite-ref-11[`F5bf`_`[11`#cite-note-11]`_`f]`:cite-ref-12[`F5bf`_`[12`#cite-note-12]`_`f]

By late 2013 the project's active phase had come to an end. In July 2016 the maintainers concluded that the time had come for "winding things up officially" because "none of us have any time to dedicate to Drizzle anymore".`:cite-ref-13[`F5bf`_`[13`#cite-note-13]`_`f]

>>Contents

• `F0af`_`[Uses`#uses]`_`f

• `F0af`_`[Platforms and interfaces`#platforms-and-interfaces]`_`f

• `F0af`_`[Features`#features]`_`f

• `F0af`_`[Microkernel`#microkernel]`_`f

• `F0af`_`[Indexes`#indexes]`_`f

• `F0af`_`[Triggers`#triggers]`_`f

• `F0af`_`[Query rewrite`#query-rewrite]`_`f

• `F0af`_`[Data types`#data-types]`_`f

• `F0af`_`[Dynamic SQL`#dynamic-sql]`_`f

• `F0af`_`[Replication`#replication]`_`f

• `F0af`_`[Support and licensing`#support-and-licensing]`_`f

• `F0af`_`[See also`#see-also]`_`f

• `F0af`_`[References`#references]`_`f

• `F0af`_`[External links`#external-links]`_`f

-─

>>Uses

Drizzle is targeted at the web-infrastructure and `F33f`_`[cloud computing`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Cloud_computing]`_`f markets. The developers of the product describe it as a "smaller, slimmer and (hopefully) faster version of MySQL".`:cite-ref-14[`F5bf`_`[14`#cite-note-14]`_`f]

>>Platforms and interfaces

Drizzle is written in the `F33f`_`[C++`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=C++]`_`f programming language, and stores its `F33f`_`[string`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=String_(computer_science)]`_`f data in the `F33f`_`[UTF-8`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=UTF-8]`_`f format. It was developed for modern `F33f`_`[Unix-like`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Unix-like]`_`f `F33f`_`[operating systems`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Operating_system]`_`f, including `F33f`_`[Linux`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Linux]`_`f, `F33f`_`[FreeBSD`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=FreeBSD]`_`f, `F33f`_`[Mac OS X`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Mac_OS_X]`_`f, and `F33f`_`[Solaris`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Solaris_(operating_system)]`_`f – in general, any OS that conforms to `F33f`_`[POSIX`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=POSIX]`_`f and has a working implementation of the GNU `F33f`_`[Autotools`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Autotools]`_`f. `F33f`_`[Microsoft Windows`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Microsoft_Windows]`_`f was not supported due to its lack of Autotools support.

>>Features

Drizzle is a re-designed version of the MySQL v6.0 codebase and is designed around a central concept of having a `F33f`_`[microkernel`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Microkernel]`_`f architecture. Features such as the query `F33f`_`[cache`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Cache_(computing)]`_`f and `F33f`_`[authentication`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Authentication]`_`f system are now `F33f`_`[plugins`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Plug-in_(computing)]`_`f to the database, which follow the general theme of "pluggable storage engines" that were introduced in MySQL 5.1. It supports `F33f`_`[PAM`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Pluggable_Authentication_Modules]`_`f, `F33f`_`[LDAP`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=LDAP]`_`f, and `F33f`_`[HTTP AUTH`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Basic_access_authentication]`_`f for authentication via plugins it ships. Via its plugin system it supports logging to files, `F33f`_`[syslog`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Syslog]`_`f, and remote services such as `F33f`_`[RabbitMQ`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=RabbitMQ]`_`f and `F33f`_`[Gearman`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Gearman]`_`f. Drizzle is an `F33f`_`[ACID`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ACID]`_`f-compliant relational database that supports transactions via an `F33f`_`[MVCC`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Multiversion_concurrency_control]`_`f design.`:cite-ref-15[`F5bf`_`[15`#cite-note-15]`_`f]

>>>Microkernel

Plugin points have been added to support `F33f`_`[replication`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Replication_(computer_science)]`_`f, `F33f`_`[storage engines`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Storage_engine]`_`f, query rewrite, table functions, `F33f`_`[user-defined functions`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=User-defined_function]`_`f, protocol adapters, and multiple query caches.

>>>Indexes

Like MySQL, Drizzle supports concurrent multiple engines. Via this, Drizzle includes built-in support for `F33f`_`[B+ tree`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=B+_tree]`_`f and `F33f`_`[hash`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Hash_table]`_`f indexes. Drizzle's query planner is capable of using multiple indexes, from multiple engines to satisfy complex queries, using temporary in-memory `F33f`_`[bitmap index`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Bitmap_index]`_`f of operations.

>>>Triggers

`F33f`_`[Database triggers`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_trigger]`_`f in Drizzle are supported for `F33f`_`[DML`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_Manipulation_Language]`_`f, `F33f`_`[DDL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_Definition_Language]`_`f, and a number of an additional event-based operations in the server. The PrimeBase BLOB streaming system, which allows Drizzle to stream `F33f`_`[binary large objects`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Binary_large_object]`_`f (BLOBs) via HTTP, makes use of this system. All triggers for Drizzle currently must be written in C++.

>>>Query rewrite

Any query can be matched and rewritten dynamically that is sent to the server. This action is done before `F33f`_`[parsing`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Parsing]`_`f occurs.

>>>Data types

A wide variety of native `F33f`_`[data types`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_type]`_`f are supported, including:

• `F33f`_`[Variable-length arrays`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Variable-length_array]`_`f (including text and composite types) up to 4 GB in total storage size

• `F33f`_`[Arbitrary precision`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Arbitrary-precision_arithmetic]`_`f `F33f`_`[numerics`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Floating_point]`_`f

• An `F33f`_`[enumerated type`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Enumerated_type]`_`f (enum) that supports current 10,000 types

>>>Dynamic SQL

Through support of the EXECUTE command Drizzle can operate dynamic multi-statement SQL. Via the keyword CONCURRENT it can operate these statements in `F33f`_`[parallel`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Concurrency_(computer_science)]`_`f.

>>>Replication

Replication in Drizzle is done by generating "messages" using the Google `F33f`_`[Protocol Buffers`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Protocol_Buffers]`_`f library. These messages are then stored and executed on remote servers. The message format is a non-SQL neutral format which has allowed Drizzle to have replication appliers to RabbitMQ, `F33f`_`[Memcached`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Memcached]`_`f, MySQL, `F33f`_`[Voldemort`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Voldemort_(distributed_data_store)]`_`f, and `F33f`_`[Apache Cassandra`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Apache_Cassandra]`_`f.

>>Support and licensing

Drizzle is licensed under version two and three of the GPL, with some parts, such as libdrizzle client library, under the `F33f`_`[BSD`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=BSD_licenses]`_`f license.

>>See also

• `F33f`_`[Comparison of relational database management systems`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Comparison_of_relational_database_management_systems]`_`f

>>References

`:cite-note-1`!1.`! "Series 7.2 : Drizzle". Launchpad.net. 23 September 2012. Retrieved 2014-07-04.

`:cite-note-2`!2.`! `F0af`_`[↑`#cite-ref-2]`_`f "MySQL fork Drizzle gets general release". `*`F33f`_`[ZDNet`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ZDNet]`_`f`*.

`:cite-note-3`!3.`! `F0af`_`[↑`#cite-ref-3]`_`f Drizzle History Archived September 2, 2013, at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

`:cite-note-4`!4.`! `F0af`_`[↑`#cite-ref-4]`_`f List of Drizzle Contributors

`:cite-note-5`!5.`! `F0af`_`[↑`#cite-ref-5]`_`f Drizzle.org

`:cite-note-6`!6.`! `F0af`_`[↑`#cite-ref-6]`_`f How Many Contributors does Drizzle Have? Archived 2010-10-23 at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

`:cite-note-7`!7.`! `F0af`_`[↑`#cite-ref-7]`_`f Drizzle7 Beta Released Archived December 13, 2010, at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

`:cite-note-8`!8.`! `F0af`_`[↑`#cite-ref-8]`_`f "Archived copy". Archived from the original on 2011-03-18. Retrieved 2011-03-16.`B100`F9d9{{cite web}}`f`b: CS1 maint: archived copy as title (link)

`:cite-note-9`!9.`! `F0af`_`[↑`#cite-ref-9]`_`f [1] Archived April 4, 2012, at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

`:cite-note-10`!10.`! `F0af`_`[↑`#cite-ref-10]`_`f [2] Archived February 10, 2012, at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

`:cite-note-11`!11.`! `F0af`_`[↑`#cite-ref-11]`_`f [3] Archived May 16, 2013, at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

`:cite-note-12`!12.`! `F0af`_`[↑`#cite-ref-12]`_`f [4] Archived April 27, 2013, at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

`:cite-note-13`!13.`! `F0af`_`[↑`#cite-ref-13]`_`f "Email to drizzle-discuss public mailing list by Brian Aker and Stewart Smith, July 27-28, 2016". Retrieved 2021-04-15.

`:cite-note-14`!14.`! `F0af`_`[↑`#cite-ref-14]`_`f Monty-says.blogspot.com

`:cite-note-15`!15.`! `F0af`_`[↑`#cite-ref-15]`_`f Drizzle Documentation Archived November 25, 2010, at the `F33f`_`[Wayback Machine`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Wayback_Machine]`_`f

>>External links

• The official website was live until 2016, http://www.drizzle.org. Waybackmachine's copy.

• Brian Aker's "What If?" article on Drizzle

• Michael Widenius's "What If" article on Drizzle

• FLOSS interview with Brian on the future direction of Drizzle

• "Drizzle". `*`F33f`_`[Freecode`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Freecode]`_`f`*.

`c`F0af`_`[↑ Back to top`#top]`_`f`a